

/****** Object:  StoredProcedure [dbo].[SP_recUser_Insert]    Script Date: 05/10/2014 08:28:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[SP_recUser_Insert]
	(
	--@UserID						[int],
	@UserCode						[varchar](50),
	@UserName						[varchar](100),
	@Email						[varchar](50),
	@Password						[varchar](50),
	@IsActive						[bit],
	@CabangID						[int],
	@NIK						[varchar](50),
	@LokasiID						[int],
	@CreatedBy						[varchar](50),
	@CreatedDate						[datetime],
	@UpdatedBy						[varchar](50),
	@UpdatedDate						[datetime],
	@IsForgotPass						[bit]
	)
AS INSERT INTO master.recUser
	(
	--UserID,
	UserCode,
	UserName,
	Email,
	Password,
	IsActive,
	CabangID,
	NIK,
	LokasiID,
	CreatedBy,
	CreatedDate,
	UpdatedBy,
	UpdatedDate,
	IsForgotPass
	)
VALUES
	(
	--@UserID,
	@UserCode,
	@UserName,
	@Email,
	@Password,
	@IsActive,
	@CabangID,
	@NIK,
	@LokasiID,
	@CreatedBy,
	@CreatedDate,
	@UpdatedBy,
	@UpdatedDate,
	@IsForgotPass
	)

GO


